﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace IT_Pro.Class
{
    class Print_InDanhMucCongViec
    {

        public static DataTable CV_GhiNhanYeuCauIT_GetByLoaiYeuCau(int loaiyc)
        {
            string procName = "CV_GhiNhanYeuCauIT_GetByLoaiYeuCau";
            SqlParameter[] parameters = new SqlParameter[1];
            parameters[0] = new SqlParameter("@LoaiYeuCau", loaiyc);
            DataTable dt= DataServices.ExcuteProcedureGetTable(procName, parameters);
            dt.Columns.Add("STT", Type.GetType("System.String"));
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dt.Rows[i]["STT"] = (i + 1).ToString();
            }
            return dt;

        }
    }
}
